SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554691 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554691 [ RunTime:0.002546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414588,199311,875981,831422,583116,618722,560526,288160,433422,851386,1037008,132137,165679,76908,403125,819400,34223,375464,885699,145852,257962,564536,225494,1023053,416829,210949,802485,366626,651823,970506,852346,561443,796515,204295,240657,759020,214629,545605,890019,651889,486877,880184,928540,113036,212609,961495,28118,275767,995113,929583,877559,553645,554366,580910,220822,737144,752025,1034459,161895,928753) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000952s ]