SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514083 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514083 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228923,510371,158892,271827,171031,966305,293832,538351,1026288,675759,629875,63838,956896,692545,1028204,489437,956055,989651,342692,696062,538990,408471,173820,357519,486039,446286,333017,20195,162021,492899,204127,469730,930254,915289,1043409,797135,12317,148739,667892,831046,826339,519128,226304,478384,1033850,583475,94424,453169,155978,196472,387110,256157,51561,659046,167296,130363,339564,726657,991342,678384) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]