SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001610s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454815 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454815 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105711,267357,497144,682987,608723,109495,621568,544292,703352,117008,190583,141078,754795,529178,504794,842734,594805,578578,374354,1037838,1011427,906677,977963,680422,875985,345042,230824,747564,379340,992828,199816,188430,850013,73056,735925,500704,331296,389116,780542,298946,918851,959310,24349,267641,300826,737613,7198,10480,757464,142405,409415,729767,1015914,835775,502301,128096,522731,346821,419299,83213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]