SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403623 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403623 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46475,122590,38730,1040257,818655,49244,708399,1012774,945400,621201,908085,979293,241561,651509,267502,587695,327938,522941,29452,317135,156197,21879,306841,820030,466020,922901,976873,772496,627876,112372,664651,727286,452365,220789,150746,769371,33760,685051,315402,135675,780519,4551,371130,356292,827111,205294,879733,552842,869194,542985,725056,939594,538069,427803,70981,247279,532362,831813,222763,322084) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]