SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 349323 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 349323 [ RunTime:0.002338s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492145,324012,11135,188481,467279,401130,88948,66541,421838,57390,661004,771731,853767,586215,1016286,321357,292185,902247,496088,647292,645717,636439,1012996,636510,142613,497826,719302,733316,586342,199803,766152,1021119,589471,913831,707203,775383,1045364,464221,462880,642373,912442,539250,320256,1016121,745739,998675,330388,42654,274060,970123,811062,744990,473466,792897,1025314,460157,792790,253771,803908,445691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 349323 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 349323 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]