SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002562s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242101 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242101 [ RunTime:0.002458s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644873,280158,547650,135604,24979,177413,685402,114865,327088,341904,1576,428401,735320,1015538,788298,813657,357819,420122,1037320,645692,727649,501442,572149,1022523,56077,194701,974732,96887,965381,1015389,327660,1013693,595510,523807,576324,256441,970767,341545,262516,469250,193869,906111,739508,767243,150987,396133,545852,45539,1021301,950682,487749,455722,593273,1022738,288201,85361,173397,148593,875934,690721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]