SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002469s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50933 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50933 [ RunTime:0.005741s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510842,531846,1048893,722299,82314,358848,87523,145689,137274,683000,707013,510628,355169,715943,770647,702862,760170,46058,533742,642706,854483,977211,284111,517573,1021411,205848,195032,138230,595766,1030906,700886,279611,136494,1033347,359277,812414,483547,113814,771010,361658,989976,809999,346868,913002,156136,389674,906874,431864,384688,1033725,966425,136297,322674,575163,308489,85551,924071,2328,1039907,626868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50933 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50933 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]