SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404876 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404876 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571155,209682,970981,857845,639965,904844,262465,643387,250163,1003345,887020,495309,902516,642008,1009181,997700,410538,11139,160925,3704,1034552,618540,482608,254036,272339,625970,33307,636000,528970,234462,784720,547788,823074,299790,1024249,767473,789973,49236,55305,342264,503744,712286,179941,378603,914474,290301,840085,276638,685436,1043043,156457,15033,459768,8993,615123,1042330,71838,989245,613286,972654) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]