SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569012 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569012 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (274715,516410,939931,28327,211914,326241,308664,412606,567617,702463,296392,22425,661225,224761,625128,449741,408486,618655,353415,424381,1020944,83904,727158,632275,216461,1024086,852643,817788,669605,709080,403158,189286,45633,236630,850842,903960,821002,120170,890087,57336,379890,28609,860377,636411,945554,605153,431204,712553,494063,113773,108535,484330,1005798,65617,514008,634482,657059,457964,287709,557465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001611s ]