SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001398s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 159643 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 159643 [ RunTime:0.003154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (715637,583590,850162,278844,280167,27071,399187,252413,809962,312206,584838,835338,400405,750511,812921,36802,835690,848173,795170,112727,225144,173522,475296,34602,787545,356032,448473,691988,755048,449677,732654,318356,230138,846157,993140,836275,329637,547939,471143,881418,579336,721282,1024485,108996,515898,786169,577771,547463,1047929,342465,818626,234884,741179,604541,806381,127905,575431,814456,604399,544679) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 159643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 159643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]