SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584091 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584091 [ RunTime:0.005455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689522,752859,561939,435256,684314,820030,799565,175563,133258,528968,1018536,490922,24461,208830,528549,8191,598403,738828,649954,74477,356782,41999,687034,714793,943794,1009566,215116,355022,153420,178349,261828,200862,440285,847373,675165,583444,903393,815080,717328,897901,17628,1047560,288367,455155,132098,580804,169098,144540,829291,15097,1019098,1048775,269380,163734,548018,996166,369238,220679,433845,524125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]