SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501121 LIMIT 1 [ RunTime:0.000287s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501121 [ RunTime:0.001572s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273067,156464,628825,317450,566125,163650,854916,140499,59595,191562,436819,27294,422411,924767,881907,1007579,540144,896119,370752,711541,368938,571714,249672,855070,236588,458609,545639,48041,925812,198847,205058,236281,803576,811381,45584,70885,454145,550610,996434,199147,428467,578937,1015532,828960,66429,358581,356981,727540,710783,917881,836226,673104,871545,789539,438348,433154,472201,963009,910094,484998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501121 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501121 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000973s ]