SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305588 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305588 [ RunTime:0.002254s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368804,953583,1004508,598704,569643,890048,349449,29291,955117,323092,87985,70401,620956,592420,769340,137349,80619,799135,391393,1014227,468474,655787,994053,611293,860563,137778,554841,687060,105384,1011725,567489,841492,361621,323488,667551,696513,1036463,335057,739438,133643,750931,675939,418365,38573,311667,832429,539230,540969,157660,940006,490070,472910,37474,672621,474123,247584,660002,432365,724015,977411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305588 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000651s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305588 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]