SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389215 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389215 [ RunTime:0.001812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303036,254624,467557,426111,467026,102461,176333,348924,122712,604035,478774,285414,630116,389230,940345,281819,159015,381650,469321,722708,1020031,908488,34594,219497,488070,85710,439963,685432,521413,487438,383220,283421,577644,334525,310993,946445,820971,298670,531080,580706,672220,1020934,144326,820204,370341,718437,945502,20381,266897,994915,285330,363125,497436,251270,1007908,947030,273137,188765,776592,279887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]