SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002962s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407438 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407438 [ RunTime:0.002684s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509162,49120,673314,19922,75619,888687,159894,46816,646722,674461,249177,376031,581038,284306,11746,567147,105327,375358,876418,194013,527363,395145,310808,301347,21197,345791,9549,881633,614889,592016,415342,620584,222549,377138,408436,905257,668485,114862,983926,353935,16575,209237,1022274,154645,569877,964066,685166,454007,816294,37969,476892,286403,321786,819048,185264,588838,929892,422287,323776,835568) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001892s ]