SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010817 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010817 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291,279330,1004987,557767,923361,193685,747689,342005,886895,136234,426215,415141,581750,789861,923779,586897,201011,62376,805559,69126,218945,239716,991947,741966,171814,716803,166844,74241,535910,327299,55576,886132,432411,329484,270373,322827,564575,285008,592121,194170,472056,315308,100745,598806,997661,720153,157330,224166,401733,726281,360649,109683,215391,446253,791541,108113,920212,775700,781731,183515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]