SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 839012 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 839012 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746984,679021,480937,924568,79441,645849,43474,1024163,175559,77483,1006246,430877,345488,330492,371701,302720,204511,281004,745275,375102,397877,1026213,26035,386195,358491,789337,937226,959663,487923,415206,859471,515214,485347,596496,346753,977871,74129,292546,569356,139481,76401,289486,530232,768794,957355,744821,856031,932965,513209,440381,146738,399041,12319,198378,1031817,663666,216568,679197,721287,965532) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 839012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 839012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001088s ]