SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439678 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439678 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040831,161490,482683,840167,316211,722385,476043,843844,646752,486378,882090,821084,956172,160761,240733,738583,41028,81639,97297,116542,349758,426158,800253,62035,107351,743860,711753,169806,705181,312630,501912,773283,263973,200070,479346,808497,2976,375538,68841,663554,783025,150620,330885,730084,1039115,456516,622977,997217,212593,497174,533422,68354,77833,745062,896539,640257,350343,206323,702249,209487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003831s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001278s ]