SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597352 LIMIT 1 [ RunTime:0.001308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597352 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855643,239746,1022520,263496,382775,998256,800420,385376,313273,42586,662907,805850,831672,107492,313517,805929,987006,931608,891703,856100,196948,730923,53187,476015,986276,584893,926245,263300,775021,477962,916106,936061,383973,1021864,282664,12427,411451,689501,1023019,515797,410897,493023,775974,14237,5479,288031,317153,393294,750764,16671,176688,391292,143100,447846,478567,576622,232249,546327,662898,833266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597352 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597352 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]