SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498611 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498611 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (703192,776369,174369,173687,147958,319280,186942,326393,483628,65151,890387,931034,994044,506800,521233,849620,1024318,533581,695311,784954,385860,440013,512116,1034773,545354,306343,756102,688167,830930,478976,456742,515988,1002901,422266,149503,467498,631273,345449,650713,795978,126140,934527,679508,18978,318549,601230,143437,912443,139089,928945,597102,49494,954337,348982,621736,532548,730004,541800,73155,255554) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001674s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]