SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520671 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520671 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986261,307623,707790,918838,881563,373985,1036169,946830,393040,886271,293089,905317,443289,552473,339932,532571,565729,918821,347875,594389,717770,899866,381377,195154,847132,965616,80449,592022,290687,182094,785243,559719,819217,619097,869553,918803,963786,558239,900734,368906,973429,704933,44594,831884,405659,741672,1022113,822204,763629,526818,535884,90193,318431,117567,478465,631701,961107,304561,925158,1005862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]