SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446284 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446284 [ RunTime:0.004185s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257838,510486,120178,556563,155373,985560,162507,417872,988265,453111,962841,660977,1001289,825950,56139,475453,703835,648135,695274,158412,40709,527771,894144,642820,375090,261206,695699,337455,997887,169048,670958,272432,919913,443838,9291,343318,981014,487303,799185,433050,915714,621426,268611,657604,171591,492859,878699,268258,157702,838151,284272,658073,59951,250889,21038,718219,21477,696271,34206,669162) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]