SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042032 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042032 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522223,901523,246565,771534,426403,519913,256329,320038,754668,866018,644775,72511,114110,343152,938125,380665,709178,878184,573102,881510,153594,122346,820471,65173,147544,677668,971480,163629,321834,464453,58492,1004339,735304,850947,133090,358914,266645,271647,800836,751687,920050,510111,1028861,570437,540395,937752,1047020,473781,926214,685347,242001,260991,259213,931614,145100,708089,1031788,357169,113426,502777) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]