SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564022 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564022 [ RunTime:0.006804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324822,148430,22124,667929,452211,843017,1008183,1038347,447051,648838,391149,174169,1024682,257756,384104,610945,22167,986623,336625,7717,870047,585513,1006576,330051,1006129,101199,721950,647040,1028254,1042203,785198,389889,29330,127422,917796,785424,361813,36135,637012,108775,44732,785802,204748,941086,304395,466084,973187,484441,239628,96622,507282,512698,392914,694131,969176,422243,309625,315568,662192,815630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]