SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587919 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587919 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332184,152462,100572,472883,969561,702697,287464,881560,1019758,148368,724417,856051,32627,20902,786733,137302,829325,650161,67432,144783,269694,1023172,262148,402970,460321,168768,588981,713419,356566,374689,968063,844322,992815,657947,475594,385449,407512,377560,1012159,808659,933848,519273,552754,1014935,241363,830861,37582,39835,192133,808925,96695,936321,101721,486553,478618,411911,249619,543261,252234,998567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]