SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4404 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4404 [ RunTime:0.003627s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676282,542425,986712,630657,13595,886213,623760,1000606,534260,199095,179702,266752,559943,433192,705528,336783,1045097,764450,32700,1031641,151665,359546,515754,97476,561255,1011155,312231,336459,831254,318568,316027,229806,203840,123789,13695,890120,939507,191638,487721,182185,384202,224073,58455,573094,45201,862700,426770,969278,862813,121791,403812,131318,58959,918847,1004134,400222,17964,671700,1012631,411808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000622s ]