SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101946 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101946 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434948,922114,130984,354997,346466,153407,37180,1045137,1005695,498306,425553,626576,912653,511902,840135,305343,774107,1029895,16317,909279,66859,738175,799450,231003,849448,490121,975552,710742,405216,970489,31857,1002899,474553,148044,920284,952390,574978,753323,932282,17258,114999,990834,271370,985257,966691,712731,175826,75667,194014,704240,817950,719232,863061,359763,669377,527729,466086,1018550,894615,42390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]