SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402028 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402028 [ RunTime:0.001705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490127,895409,191802,603397,525533,894725,458855,363377,662853,1020252,757458,781361,35227,845674,844493,780295,6895,613519,944238,102657,654728,76580,1026779,950495,275359,342876,798546,655743,868414,557763,77294,63320,869384,240999,813233,642205,61457,957687,910152,788550,941485,149025,6436,865512,529840,944665,264148,126534,899847,947285,153145,785405,664358,526179,450021,313455,354291,83407,937128,99788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]