SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412117 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412117 [ RunTime:0.001872s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17550,613295,839383,866356,252522,873936,525623,666203,750697,204694,283204,82816,149082,193917,155974,93989,451398,551297,471454,209095,887448,784764,322459,712457,1018832,601032,927383,27203,294068,671380,162003,144871,253805,561877,525439,299721,767681,453232,639391,1024286,765926,1003532,967002,537631,703359,389040,555824,519241,481889,310536,409872,402037,523343,430524,537064,335388,813522,647457,869079,756956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000582s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]