SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514931 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514931 [ RunTime:0.002535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338561,323915,40768,966178,437856,247600,445963,844842,518477,912901,928852,25205,817403,875985,93085,1007566,862045,914126,266009,19715,488619,669672,286087,67114,604990,1010290,765861,277619,236333,266950,526952,439642,446636,844888,197290,622757,915019,445429,656637,221847,139634,920093,300834,273075,263612,618566,179213,618728,820883,245947,632402,174876,1026208,357075,922768,6831,429593,661395,605035,275116) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000932s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514931 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514931 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]