SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505803 LIMIT 1 [ RunTime:0.003666s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505803 [ RunTime:0.003778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851836,238650,151777,695625,269069,157304,498755,668324,662139,665324,842382,573301,552297,299080,94807,14968,595928,125975,833474,598381,937234,165512,863722,9949,953679,327635,84384,52716,461169,993614,722097,753374,738349,371003,640325,789749,227297,902221,174718,163675,788779,92963,788304,1002283,1028638,380902,929775,535058,996905,1035717,527927,431784,551419,980870,112025,911595,868837,268877,491614,477685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000930s ]