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` = 1013630 LIMIT 1 [ RunTime:0.001475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013630 [ RunTime:0.005048s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (785117,358977,219483,121457,121274,903585,89431,32860,933697,264214,281457,726406,998063,612707,246087,909288,984675,700580,177877,446298,944618,714968,128914,707390,514158,401191,871969,727514,908710,199260,611196,672080,138549,858829,364727,705775,490318,689792,262365,185902,183303,1025148,796744,331597,519160,56612,141500,390912,280699,972335,930497,894722,996185,810287,565083,323319,510617,797456,662706,566622) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013630 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013630 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]