SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001783s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039048 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039048 [ RunTime:0.002111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194785,641275,228770,597139,967372,1014776,922749,715810,327239,277482,231581,126114,717194,864676,158404,230385,763862,1020450,155304,785586,709842,379165,371047,68127,250078,349144,741598,674724,852630,156115,201335,521455,448839,960435,644262,565921,579097,247811,202436,333840,978009,555560,566686,752704,897160,962317,507655,601241,448096,771368,369720,718370,232082,383154,626859,394968,345141,570431,1036998,211014) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001529s ]