SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 722080 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 722080 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724510,531966,840923,274282,150522,814809,736217,1021201,639096,1028273,883920,850619,42657,327182,426818,522527,942558,617894,460328,949366,1017337,12744,1021643,65375,1027970,380218,437064,218949,511270,723972,357564,110007,263662,936002,469374,88173,953523,812269,182425,199143,359781,911784,966911,146694,633718,243990,202358,1019371,1039975,51429,452337,405303,935556,384790,890398,505635,191639,1046404,105905,403680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 722080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 722080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]