SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001009 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001009 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754367,477122,519163,377453,716154,868762,146994,675080,363966,526680,818677,546550,913611,606566,399164,130471,336323,295378,414483,106804,968630,675589,299832,348521,379118,194098,1014485,568598,742614,674534,1038568,788110,431437,67917,761130,292515,182397,768344,1009872,75440,290790,1023972,255042,1010284,815339,222065,180961,625443,457149,816450,626944,513251,32357,92268,103110,799693,302173,435058,996899,903002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001710s ]