SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009235 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009235 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459880,752523,165525,367644,650169,851518,897595,625709,310995,115432,57891,470240,845607,771243,740575,74897,909037,98409,81424,241803,159922,267264,910498,676699,1010642,702949,770174,787011,580358,191403,224156,317928,776756,573171,853917,556689,238890,741954,988934,501779,195367,856584,741115,695831,704123,1025347,933998,367389,963586,769562,740481,308730,964577,452165,41644,570663,283817,533132,149241,535347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009235 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009235 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]