SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103954 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103954 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (847236,139475,286501,371181,80764,465835,1005821,56353,39136,743553,900373,264512,161220,765177,1001419,624506,513216,186884,263828,223220,667610,423154,86679,323339,69591,802245,759619,397936,846339,443712,122375,624497,827849,911600,566648,504111,518490,431969,717740,1012231,99498,125959,514871,962450,547246,862756,546798,400420,915188,496356,380321,165400,614338,984389,732614,490298,1041995,1029906,279328,382713) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]