SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 915438 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 915438 [ RunTime:0.001511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496056,512644,391318,558070,39104,834715,392372,783084,792841,501748,975265,431405,943793,516942,396484,588786,630581,1031110,654451,268154,197336,623312,255597,111004,193040,221773,249561,402143,118723,441626,125008,76438,813543,907076,840323,108238,190880,12896,787068,104408,409673,705900,719124,48047,780655,43870,1031131,869760,675772,927826,101957,106605,524381,228666,448883,329048,605003,903759,754194,638441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 915438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 915438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]