SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205578 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205578 [ RunTime:0.001935s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857183,244396,407188,406370,294345,705145,1022333,904152,811901,392903,427471,261856,882831,923202,377370,50544,535727,970528,39200,608742,556774,480563,385891,834545,355733,475742,521724,307812,907621,276257,245987,509472,15547,875987,1016771,905235,1004102,188372,725505,151454,136326,160011,710817,262224,836396,973785,742757,992722,702701,75309,768315,843206,972431,588650,813402,457794,634456,164533,78681,32625) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000387s ]