SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 994810 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 994810 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018233,818037,1019037,33268,603147,840552,175884,307554,310999,1000225,498156,750852,815687,64543,576614,278929,888171,364770,35810,246451,824218,445587,408096,881505,61593,371092,897644,987838,42172,655824,277580,143441,102388,741069,429573,674354,968845,1015610,394669,867701,914356,816633,651281,331268,686276,954028,802833,844623,818320,121016,41508,401988,945947,188556,691329,146149,139029,996246,117540,730603) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 994810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 994810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000732s ]