SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102758 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102758 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692845,574247,975881,21651,693122,436126,472265,805278,544357,86230,412621,728339,175780,441396,680973,842053,506824,938150,267008,543351,943011,548210,953214,302927,939624,933142,327966,50111,614631,521996,817745,225345,74881,511045,90215,434562,512703,348048,771783,292377,810095,928717,58313,425062,569962,920240,888220,319375,886267,463295,1029036,967063,665989,857868,862920,228261,659817,905560,503993,577871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102758 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102758 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]