SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 307213 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 307213 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303792,946481,574905,1040375,705556,816598,3985,811163,914096,891685,36212,1034783,804774,540620,510500,421230,691174,180039,101875,124318,153234,465358,217294,163175,502110,649230,43646,648611,492358,455122,104825,295489,48710,393825,378862,1014928,309096,45984,489565,552470,508042,664261,433491,819611,206888,310615,159454,437505,365029,865959,954413,612607,873842,993052,163144,49545,1013165,161985,83406,69649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 307213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 307213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]