SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506309 LIMIT 1 [ RunTime:0.000618s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506309 [ RunTime:0.002003s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291064,947742,290906,396670,585568,661748,662534,959655,1006155,523601,422121,1029421,201591,278712,366054,417655,770250,758505,584474,234360,703630,1036701,961967,550107,301847,275413,535079,1023669,239366,102837,320192,563838,815919,867789,1020359,720676,823369,369797,190339,774935,474173,162939,929359,976152,101724,887401,261116,494604,283623,865777,185649,991498,171578,164530,833366,94155,227879,103015,405176,555599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]