SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504029 LIMIT 1 [ RunTime:0.002868s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504029 [ RunTime:0.009806s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780607,668697,961141,714866,671377,538101,458649,306046,846266,1011159,818010,980685,146598,880584,101975,787901,23515,717545,142797,396331,320881,895231,915699,1005358,21643,326227,699578,743116,68018,409268,923030,728558,853173,1036344,1003648,152124,834167,215240,57428,343948,866226,448320,452640,452428,378409,675048,123757,376400,962714,404241,585638,112974,208488,919708,716552,513615,401409,225560,813837,509717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000781s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]