SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467712 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467712 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528628,361497,793258,876642,41497,797761,569276,469976,122767,468672,461517,218089,798312,885347,56075,176929,697100,226185,188331,386323,395298,542970,224497,223245,685969,794636,707893,112744,284532,310039,917196,444257,118952,388082,387511,294799,605172,624078,878320,645030,666473,731318,799587,279843,80825,312525,227454,409131,553847,419227,149560,717385,78242,752353,147105,155903,364850,324424,521347,1022617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]