SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293964 LIMIT 1 [ RunTime:0.002523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293964 [ RunTime:0.003985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (602165,1027178,213607,68259,589586,781401,135454,986080,217009,831653,668587,346030,634151,637479,631120,475733,564358,922969,51886,692797,430213,593976,314040,606733,1031981,947637,50872,108086,322738,276094,954928,22001,500614,873655,116292,368748,155383,80686,577520,248796,323148,549782,396777,447105,335518,125910,777124,195306,693235,250149,537527,559957,947661,497981,447796,628074,635192,90098,304044,1024297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002268s ]