SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504140 LIMIT 1 [ RunTime:0.001122s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504140 [ RunTime:0.001873s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634631,172360,122417,688066,379205,630281,131737,433225,339224,781438,74379,559265,484709,949626,686191,330222,950937,622942,149039,885972,362314,136547,178988,48816,985868,408060,110238,378011,146562,193733,134709,889661,381599,308561,547865,616192,499639,301022,636035,672941,251304,317939,793709,123270,257638,166191,457649,967061,181017,52811,644568,167911,404093,408157,705352,265617,112926,810167,926026,759103) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]