SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939884 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939884 [ RunTime:0.002781s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (88072,36767,184097,893731,1042011,832239,880048,418619,741635,331682,574561,499867,940963,974802,501262,423583,301291,129556,82521,156015,587909,263691,440737,380021,380299,591335,374574,788327,212003,707480,771731,767061,1039893,7175,363640,206331,1032431,1038048,331044,391004,384188,856357,13720,506590,183157,461612,348872,804759,299472,4591,886129,637785,999796,1036874,301451,317798,832786,120307,281075,138072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000832s ]