SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530809 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530809 [ RunTime:0.002526s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517051,719202,62922,275038,56514,263265,371735,540707,277645,196934,119525,1025077,80695,774333,120016,655699,1030539,560487,63857,907047,538927,95014,1015924,814805,347402,396236,167837,464400,722867,572472,1011398,710191,300748,808684,854475,160034,650157,77924,854306,458336,998752,257487,4867,469864,556935,306807,1043389,11248,1048118,65237,513173,545572,102402,930240,278928,11509,832539,216843,474125,823100) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]