SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554180 LIMIT 1 [ RunTime:0.001436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554180 [ RunTime:0.004943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833728,511774,544446,693154,510659,115834,232624,144899,1002183,1016261,450503,539104,508311,4414,324414,566714,739067,927971,511556,100297,904435,136342,474178,445994,264355,820419,995067,281773,790492,64768,205683,750189,859997,660673,387729,840422,660482,169783,1021973,967150,438942,419589,66109,847361,800490,576720,873755,358066,368331,665008,917411,766399,236252,944457,605097,416843,787416,187483,417310,652196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]