SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 556263 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556263 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92533,86145,389303,815646,1011308,816293,561147,459300,490288,761589,104560,960424,138368,623237,960011,951081,27400,880418,894555,651454,895855,560071,2986,379462,923852,552332,792162,332009,571027,984281,793856,192597,571000,155587,618876,75402,797654,26953,677325,2819,8558,812072,463090,139635,716150,497342,437059,819313,86821,166724,1012215,677792,944076,782950,263923,735167,667889,394233,677257,68393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]