SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409138 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409138 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207503,119793,688071,95268,1031518,264061,242577,239530,650632,855723,861303,657756,337451,1043452,358822,1014026,651445,621659,256778,1011906,302966,652897,302009,199256,346639,789092,515565,4599,725468,1038678,189875,680883,285290,233678,894788,447079,288166,878673,145075,648341,1010980,566425,542876,182698,575865,246845,156111,676828,674409,482506,316833,609129,474210,530369,711472,665956,355703,764853,108781,161138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001836s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]