SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341420 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341420 [ RunTime:0.001653s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44001,933776,443344,1037772,95598,290137,562357,588279,911632,646281,127158,468811,1020446,901179,59902,842539,680004,276106,479153,429512,1021051,278015,219569,370547,392857,47991,319693,982256,194236,364576,207341,10683,74148,283882,305254,206114,335768,559343,809188,1029259,419994,887286,590147,183579,705419,752290,1000563,457763,686000,834904,87245,309122,209897,562346,497326,1024999,990774,897760,635983,904215) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]