SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473813 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473813 [ RunTime:0.003987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (209259,515347,967500,148780,12001,104593,126624,365051,360213,235198,592956,548416,463660,173281,197092,688011,617409,65809,183249,966757,787524,627410,92033,499393,809791,832292,206893,45055,1025350,657279,109923,542565,892630,740305,1036566,304905,373753,750665,739534,499838,631110,985118,834601,504378,1037592,747318,210728,418695,682553,780464,682057,540975,687198,392463,1038439,849992,927375,82639,902078,735123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]