SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039996 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039996 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264762,951219,710674,674648,891706,62733,548142,769868,478995,563620,798249,873508,1016861,448509,1000438,156389,965556,547019,543641,51323,872479,159409,761139,571921,502484,248158,17146,76341,545202,851936,312190,266263,126283,842952,19219,502657,655668,51083,722343,927758,1014928,815195,127695,769947,707602,389212,981390,852162,22516,890770,303190,4168,304821,191781,71054,647567,788486,275735,779050,1009336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000442s ]