SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043567 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043567 [ RunTime:0.002948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (925809,631048,57866,560434,454872,375552,410704,318474,438111,436938,870755,327492,284238,144104,1036997,94575,719952,650756,401734,177165,612952,779783,609262,321083,116587,611390,154102,209812,251299,173590,652624,268180,671693,770507,552821,602945,491175,543548,621915,372814,936,752916,56983,760341,308503,308696,1028203,272329,1011088,171172,705402,478886,877109,962928,261978,1025306,642248,1027080,575925,761560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000850s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000730s ]