SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100320 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100320 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120783,184519,1016969,914247,988781,205199,56430,823920,482697,616331,63534,976950,192984,711611,406015,1041835,662814,445270,204406,631077,451022,140845,1026235,710794,981390,59636,423636,974582,262223,703145,477699,721010,410066,106470,27469,182490,365031,590133,60979,580648,332247,213357,815579,1037601,140247,458227,288769,616163,951990,262312,221286,834088,263063,442126,625279,1002064,673091,879336,641492,861030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]