SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414012 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414012 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405449,621631,850629,877280,668377,995836,928867,949200,161295,375745,724145,198728,362313,239427,789031,244303,453488,927581,638288,148837,127961,474797,913761,442903,776374,1022857,229898,270221,733933,320113,503393,648066,679112,45284,602138,374201,969434,445195,750428,967176,134554,468866,1028528,990349,24574,527034,810901,494474,480896,181993,20823,956604,781689,423835,350000,521438,584961,574729,124526,344771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]