SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671558 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671558 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191442,837132,490663,448951,263929,960450,707258,97152,630436,29898,31968,317601,591370,391637,484614,338295,312351,689835,721118,24781,294374,4811,818827,607991,467147,353875,609857,321130,437560,865591,956594,923732,70213,676924,809528,459778,301453,750452,644839,4770,330686,441004,851594,294658,1002652,424608,519138,619494,945490,265223,879672,705151,322077,57228,509370,222705,877589,569686,749004,1035545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671558 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671558 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000383s ]