SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005756s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255798 LIMIT 1 [ RunTime:0.000869s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255798 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (54795,735578,571221,843205,450737,779634,523901,729974,887864,345395,338537,556364,410057,244606,988838,865282,270231,669821,595245,592707,953079,997247,1012317,117268,1003358,237201,969131,12887,646383,461065,278118,873189,487355,361017,679379,842951,233425,430070,198388,180466,204967,753185,287351,966559,188883,471141,454622,273904,718414,85636,157836,901423,917119,601702,807966,249418,31425,91387,943848,581465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002412s ]