SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009600 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009600 [ RunTime:0.001076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211049,596781,905965,805063,221512,501380,781485,95776,994880,976693,10459,450160,881384,757198,275757,528184,367483,422740,992835,529056,701173,780242,409775,982108,883474,123873,632899,330406,597523,868210,720503,918859,62262,404207,999393,550259,1015611,231877,680788,1031111,94172,777102,611897,401168,484826,52989,133784,761172,47489,305641,151852,769870,64215,803033,942491,642116,675593,103887,178321,878867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]